Run Script with Excel in Power Automate |
您所在的位置:网站首页 › automate excel › Run Script with Excel in Power Automate |
Did you notice the new run script action in the Excel connector when you use Power Automate? ![]() Table of Contents When you start with this action you will most likely bump into the There’s a problem error. Within the sea of junk you might find the clue! ![]() The important line is: Office Scripts Platform is disabled. To enable Office Scripts you will have to go to your Office 365 Admin Center. In the admin center go to Setting -> Org settings and search for office scripts and then tick the box. This will Let users automate their tasks in Office on the web. ![]() Once you have done this you will get: ![]() Now we got to a blank screen kind of thing! What can we do with Scripts? Run Scripts in the Excel connectorOpen your excel file on office online and you will notice the automate option. ![]() Click on the New Script and your first script is there ![]() And now when you try again we will see the Script 1 that we just created. ![]() If you want to learn about this scripting language in excel then you could always start by using the record option when you create a new script. I remember many years ago developing an app in Excel. I wouldn’t recommend using this kind of scripting to develop full blown apps in Excel. The run Script is more for small steps that you want to complete in an Excel. ![]() Just as an example. Creating Tables in Excel from a flow can be painful, but if you can create them using a script inside your Excel then that might quite well work. This Run Script action gives us unlimited options in Excel, however if you are serious about your data, I would still recommend using a proper database. See alsoDaniel Laskewitz’s video about Scripts in Excel Share this:WhatsAppEmailMoreTweetMastodonLike this:Like Loading...Related |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |